SELECT `weapon`.`idweapon`, `weapon`.`name`, `ammo_dmg`.`caliber`,`wpntype`.`name`, `weapon`.`class`, `weapon`.`hands`, `weapon`.`dmgtype`, `weapon`.`range`, `weapon`.`error`, `weapon`.`threat`, `weapon`.`rate`, `weapon`.`reqstr`, `weapon`.`reqdex`, `weapon`.`capacity`, `weapon`.`mags`, `ammo`.`abbr`, `weapon`.`pic`, `weapon`.`complexity`, `weapon`.`cost`, `weapon`.`restrict`, `weapon`.`idupgrade1`, `weapon`.`idupgrade2`, `weapon`.`idupgrade3`, `trait1`.`abbr`, `trait2`.`abbr`, `trait3`.`abbr`, `weapon`.`conceal`, `weapon`.`desc`, `weapon`.`terse`, `weapon`.`adjectives`, `weapon`.`synonyms`, `weapon`.`uuid`, `weapon`.`dur_curr`, `weapon`.`dur_max`, `weapon`.`upgrades`
FROM weapon
JOIN wpntype ON weapon.idwpntype = wpntype.idwpntype
JOIN ammo_dmg ON weapon.idcaliber = ammo_dmg.idammo_dmg
JOIN ammo ON weapon.idammo = ammo.idammo
LEFT JOIN trait trait1 ON weapon.idtrait1 = trait1.idtrait
LEFT JOIN trait trait2 ON weapon.idtrait2 = trait2.idtrait
LEFT JOIN trait trait3 ON weapon.idtrait3 = trait3.idtrait;
